Dataset statistics
| Number of variables | 39 |
|---|---|
| Number of observations | 1582 |
| Missing cells | 7203 |
| Missing cells (%) | 11.7% |
| Duplicate rows | 94 |
| Duplicate rows (%) | 5.9% |
| Total size in memory | 482.1 KiB |
| Average record size in memory | 312.1 B |
Variable types
| DateTime | 5 |
|---|---|
| Numeric | 7 |
| Categorical | 23 |
| Unsupported | 3 |
| Boolean | 1 |
LOB has constant value "FMCG" | Constant |
BP TYPE has constant value "RENTAL" | Constant |
Transfer Type has constant value "Pallet CompanyOUT" | Constant |
PRODUCT CATEGORY has constant value "Wooden Pallet" | Constant |
UNIT has constant value "Nos" | Constant |
Document Type has constant value "Allot" | Constant |
Detention has constant value "0.0" | Constant |
| Dataset has 94 (5.9%) duplicate rows | Duplicates |
Customer/Vendor Name has a high cardinality: 143 distinct values | High cardinality |
City has a high cardinality: 62 distinct values | High cardinality |
TO WhsName has a high cardinality: 143 distinct values | High cardinality |
SO ID has a high cardinality: 424 distinct values | High cardinality |
Customer/Vendor Code is highly correlated with Region and 7 other fields | High correlation |
To whsCode is highly correlated with Customer/Vendor Code and 7 other fields | High correlation |
Region is highly correlated with Customer/Vendor Code and 6 other fields | High correlation |
From WhsCode is highly correlated with Customer/Vendor Code and 12 other fields | High correlation |
U_ActShipType is highly correlated with Customer/Vendor Code and 3 other fields | High correlation |
ItemCode is highly correlated with Model TYPE and 5 other fields | High correlation |
BP TYPE is highly correlated with Region and 19 other fields | High correlation |
Detention is highly correlated with Region and 19 other fields | High correlation |
U_SOTYPE is highly correlated with Model TYPE and 4 other fields | High correlation |
U_AssetClass is highly correlated with ItemCode and 2 other fields | High correlation |
UNIT is highly correlated with Region and 19 other fields | High correlation |
LOB is highly correlated with Region and 19 other fields | High correlation |
U_DocStatus is highly correlated with From WhsCode | High correlation |
Direct Dispatch is highly correlated with From WhsCode and 2 other fields | High correlation |
STATE is highly correlated with Customer/Vendor Code and 7 other fields | High correlation |
From WhsName is highly correlated with Customer/Vendor Code and 8 other fields | High correlation |
City is highly correlated with Customer/Vendor Code and 9 other fields | High correlation |
Document Type is highly correlated with Region and 19 other fields | High correlation |
Vehicle Type is highly correlated with Region and 11 other fields | High correlation |
BP CATEGORY is highly correlated with Customer/Vendor Code and 1 other fields | High correlation |
PRODUCT CATEGORY is highly correlated with Region and 19 other fields | High correlation |
Transfer Type is highly correlated with Region and 19 other fields | High correlation |
Model TYPE is highly correlated with ItemCode and 3 other fields | High correlation |
QUANTITY is highly correlated with City and 5 other fields | High correlation |
RATE is highly correlated with Model TYPE and 4 other fields | High correlation |
U_GRNNO is highly correlated with City and 1 other fields | High correlation |
Loading/Unloading is highly correlated with City and 3 other fields | High correlation |
NumAtCard has 1582 (100.0%) missing values | Missing |
Comments has 1549 (97.9%) missing values | Missing |
U_GRNNO has 861 (54.4%) missing values | Missing |
Loading/Unloading has 487 (30.8%) missing values | Missing |
Detention has 1138 (71.9%) missing values | Missing |
KITITEM has 1582 (100.0%) missing values | Missing |
NumAtCard is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Comments is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
KITITEM is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
U_Frt has 281 (17.8%) zeros | Zeros |
Loading/Unloading has 1065 (67.3%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-30 17:17:52.591326 |
|---|---|
| Analysis finished | 2023-04-30 17:18:06.783848 |
| Duration | 14.19 seconds |
| Software version | pandas-profiling v3.3.0 |
| Download configuration | config.json |
POSTING DATE
Date
| Distinct | 479 |
|---|---|
| Distinct (%) | 30.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Minimum | 2019-12-06 00:00:00 |
|---|---|
| Maximum | 2022-11-26 00:00:00 |
EFFECTIVE DATE
Date
| Distinct | 472 |
|---|---|
| Distinct (%) | 29.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Minimum | 2019-12-06 00:00:00 |
|---|---|
| Maximum | 2022-11-26 00:00:00 |
CREATE DATE
Date
| Distinct | 479 |
|---|---|
| Distinct (%) | 30.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Minimum | 2019-12-06 00:00:00 |
|---|---|
| Maximum | 2022-11-26 00:00:00 |
| Distinct | 143 |
|---|---|
| Distinct (%) | 9.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10004860.78 |
| Minimum | 10000408 |
|---|---|
| Maximum | 10008338 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.5 KiB |
Quantile statistics
| Minimum | 10000408 |
|---|---|
| 5-th percentile | 10001316 |
| Q1 | 10002425 |
| median | 10006243 |
| Q3 | 10006524 |
| 95-th percentile | 10006966.9 |
| Maximum | 10008338 |
| Range | 7930 |
| Interquartile range (IQR) | 4099 |
Descriptive statistics
| Standard deviation | 2238.812447 |
|---|---|
| Coefficient of variation (CV) | 0.0002237724738 |
| Kurtosis | -1.390454343 |
| Mean | 10004860.78 |
| Median Absolute Deviation (MAD) | 480 |
| Skewness | -0.615446634 |
| Sum | 1.582768975 × 1010 |
| Variance | 5012281.171 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10002430 | 87 | 5.5% |
| 10006243 | 67 | 4.2% |
| 10006334 | 63 | 4.0% |
| 10006453 | 51 | 3.2% |
| 10002391 | 50 | 3.2% |
| 10005871 | 48 | 3.0% |
| 10001378 | 45 | 2.8% |
| 10006335 | 42 | 2.7% |
| 10002436 | 42 | 2.7% |
| 10006678 | 39 | 2.5% |
| Other values (133) | 1048 |
| Value | Count | Frequency (%) |
| 10000408 | 8 | 0.5% |
| 10000411 | 1 | 0.1% |
| 10000413 | 2 | 0.1% |
| 10000462 | 1 | 0.1% |
| 10000740 | 7 | 0.4% |
| 10001155 | 20 | |
| 10001216 | 29 | |
| 10001316 | 14 | |
| 10001317 | 4 | 0.3% |
| 10001319 | 15 |
| Value | Count | Frequency (%) |
| 10008338 | 1 | 0.1% |
| 10008314 | 5 | 0.3% |
| 10008112 | 1 | 0.1% |
| 10008009 | 1 | 0.1% |
| 10007944 | 2 | 0.1% |
| 10007809 | 19 | |
| 10007735 | 2 | 0.1% |
| 10007480 | 2 | 0.1% |
| 10007353 | 6 | 0.4% |
| 10007199 | 32 |
| Distinct | 143 |
|---|---|
| Distinct (%) | 9.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Cart Services Pvt. Ltd. _ Kolkata _Bagnan | 87 |
|---|---|
| Cart Services Pvt. Ltd. _ Coimbatore_ Selakarichal | 67 |
| Cart Services Private Limited_Rewari_Khijuri | 63 |
| Cart Services Private Limited_Bhiwandi_Saidham_G Whse_Unit 2 | 51 |
| Cart Services Pvt. Ltd. _ Bangalore _Venkatapura Village Malur | 50 |
| Other values (138) |
Length
| Max length | 70 |
|---|---|
| Median length | 56 |
| Mean length | 45.63337547 |
| Min length | 28 |
Characters and Unicode
| Total characters | 72192 |
|---|---|
| Distinct characters | 62 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 43 ? |
|---|---|
| Unique (%) | 2.7% |
Sample
| 1st row | Cart Services Pvt. Ltd. _ Howrah _Uluberia ESR Warehousing |
|---|---|
| 2nd row | Cart Services Pvt. Ltd. _ Howrah _Uluberia ESR Warehousing |
| 3rd row | Cart Services Pvt Ltd _ Gurgoan _Embassy Industrial |
| 4th row | Cart Services Pvt. Ltd. _ Gurgoan _ Tauru |
| 5th row | Cart Services Pvt. Ltd. _ Gurgoan _ Tauru |
Common Values
| Value | Count | Frequency (%) |
| Cart Services Pvt. Ltd. _ Kolkata _Bagnan | 87 | 5.5% |
| Cart Services Pvt. Ltd. _ Coimbatore_ Selakarichal | 67 | 4.2% |
| Cart Services Private Limited_Rewari_Khijuri | 63 | 4.0% |
| Cart Services Private Limited_Bhiwandi_Saidham_G Whse_Unit 2 | 51 | 3.2% |
| Cart Services Pvt. Ltd. _ Bangalore _Venkatapura Village Malur | 50 | 3.2% |
| Cart Services Pvt. Ltd. _Hosur | 48 | 3.0% |
| Cart Services Pvt. Ltd. _ Ludhiana | 45 | 2.8% |
| Cart Services Private Limited_Thiruvallur_Orakkadu | 42 | 2.7% |
| Cart Services Pvt. Ltd. _ Hosur _U2 BTS Large | 42 | 2.7% |
| Cart Services Private Limited_Haringhata | 39 | 2.5% |
| Other values (133) | 1048 |
Length
| Value | Count | Frequency (%) |
| cart | 1576 | |
| services | 1576 | |
| 1174 | ||
| pvt | 1069 | 10.4% |
| ltd | 1017 | 9.9% |
| private | 513 | 5.0% |
| limited | 164 | 1.6% |
| bangalore | 150 | 1.5% |
| bhiwandi | 114 | 1.1% |
| hyderabad | 96 | 0.9% |
| Other values (204) | 2811 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8826 | 12.2% | |
| a | 6543 | 9.1% |
| r | 5490 | 7.6% |
| e | 5489 | 7.6% |
| t | 5430 | 7.5% |
| i | 4870 | 6.7% |
| v | 3298 | 4.6% |
| _ | 3110 | 4.3% |
| d | 2563 | 3.6% |
| . | 2056 | 2.8% |
| Other values (52) | 24517 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 47282 | |
| Uppercase Letter | 10543 | 14.6% |
| Space Separator | 8826 | 12.2% |
| Connector Punctuation | 3110 | 4.3% |
| Other Punctuation | 2071 | 2.9% |
| Decimal Number | 360 | 0.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 6543 | |
| r | 5490 | |
| e | 5489 | |
| t | 5430 | |
| i | 4870 | |
| v | 3298 | 7.0% |
| d | 2563 | 5.4% |
| s | 1960 | 4.1% |
| c | 1716 | 3.6% |
| n | 1399 | 3.0% |
| Other values (15) | 8524 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1931 | |
| C | 1867 | |
| L | 1785 | |
| P | 1676 | |
| B | 614 | 5.8% |
| H | 384 | 3.6% |
| K | 255 | 2.4% |
| M | 240 | 2.3% |
| G | 210 | 2.0% |
| F | 184 | 1.7% |
| Other values (15) | 1397 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 170 | |
| 1 | 60 | 16.7% |
| 8 | 34 | 9.4% |
| 0 | 33 | 9.2% |
| 3 | 26 | 7.2% |
| 6 | 20 | 5.6% |
| 4 | 14 | 3.9% |
| 9 | 3 | 0.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 2056 | |
| , | 15 | 0.7% |
Space Separator
| Value | Count | Frequency (%) |
| 8826 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 3110 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 57825 | |
| Common | 14367 | 19.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 6543 | 11.3% |
| r | 5490 | 9.5% |
| e | 5489 | 9.5% |
| t | 5430 | 9.4% |
| i | 4870 | 8.4% |
| v | 3298 | 5.7% |
| d | 2563 | 4.4% |
| s | 1960 | 3.4% |
| S | 1931 | 3.3% |
| C | 1867 | 3.2% |
| Other values (40) | 18384 |
Common
| Value | Count | Frequency (%) |
| 8826 | ||
| _ | 3110 | 21.6% |
| . | 2056 | 14.3% |
| 2 | 170 | 1.2% |
| 1 | 60 | 0.4% |
| 8 | 34 | 0.2% |
| 0 | 33 | 0.2% |
| 3 | 26 | 0.2% |
| 6 | 20 | 0.1% |
| , | 15 | 0.1% |
| Other values (2) | 17 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 72192 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 8826 | 12.2% | |
| a | 6543 | 9.1% |
| r | 5490 | 7.6% |
| e | 5489 | 7.6% |
| t | 5430 | 7.5% |
| i | 4870 | 6.7% |
| v | 3298 | 4.6% |
| _ | 3110 | 4.3% |
| d | 2563 | 3.6% |
| . | 2056 | 2.8% |
| Other values (52) | 24517 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| FMCG |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 6328 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FMCG |
|---|---|
| 2nd row | FMCG |
| 3rd row | FMCG |
| 4th row | FMCG |
| 5th row | FMCG |
Common Values
| Value | Count | Frequency (%) |
| FMCG | 1582 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| fmcg | 1582 |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 1582 | |
| M | 1582 | |
| C | 1582 | |
| G | 1582 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 6328 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 1582 | |
| M | 1582 | |
| C | 1582 | |
| G | 1582 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6328 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 1582 | |
| M | 1582 | |
| C | 1582 | |
| G | 1582 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6328 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| F | 1582 | |
| M | 1582 | |
| C | 1582 | |
| G | 1582 |
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| South | |
|---|---|
| North | |
| East | |
| West |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.618836915 |
| Min length | 4 |
Characters and Unicode
| Total characters | 7307 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | East |
|---|---|
| 2nd row | East |
| 3rd row | North |
| 4th row | North |
| 5th row | North |
Common Values
| Value | Count | Frequency (%) |
| South | 618 | |
| North | 361 | |
| East | 305 | |
| West | 298 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| south | 618 | |
| north | 361 | |
| east | 305 | |
| west | 298 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 1582 | |
| o | 979 | |
| h | 979 | |
| S | 618 | 8.5% |
| u | 618 | 8.5% |
| s | 603 | 8.3% |
| N | 361 | 4.9% |
| r | 361 | 4.9% |
| E | 305 | 4.2% |
| a | 305 | 4.2% |
| Other values (2) | 596 | 8.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5725 | |
| Uppercase Letter | 1582 | 21.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 1582 | |
| o | 979 | |
| h | 979 | |
| u | 618 | 10.8% |
| s | 603 | 10.5% |
| r | 361 | 6.3% |
| a | 305 | 5.3% |
| e | 298 | 5.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 618 | |
| N | 361 | |
| E | 305 | |
| W | 298 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7307 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 1582 | |
| o | 979 | |
| h | 979 | |
| S | 618 | 8.5% |
| u | 618 | 8.5% |
| s | 603 | 8.3% |
| N | 361 | 4.9% |
| r | 361 | 4.9% |
| E | 305 | 4.2% |
| a | 305 | 4.2% |
| Other values (2) | 596 | 8.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7307 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 1582 | |
| o | 979 | |
| h | 979 | |
| S | 618 | 8.5% |
| u | 618 | 8.5% |
| s | 603 | 8.3% |
| N | 361 | 4.9% |
| r | 361 | 4.9% |
| E | 305 | 4.2% |
| a | 305 | 4.2% |
| Other values (2) | 596 | 8.2% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| RENTAL |
|---|
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 9492 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RENTAL |
|---|---|
| 2nd row | RENTAL |
| 3rd row | RENTAL |
| 4th row | RENTAL |
| 5th row | RENTAL |
Common Values
| Value | Count | Frequency (%) |
| RENTAL | 1582 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| rental | 1582 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 1582 | |
| E | 1582 | |
| N | 1582 | |
| T | 1582 | |
| A | 1582 | |
| L | 1582 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 9492 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 1582 | |
| E | 1582 | |
| N | 1582 | |
| T | 1582 | |
| A | 1582 | |
| L | 1582 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9492 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 1582 | |
| E | 1582 | |
| N | 1582 | |
| T | 1582 | |
| A | 1582 | |
| L | 1582 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9492 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 1582 | |
| E | 1582 | |
| N | 1582 | |
| T | 1582 | |
| A | 1582 | |
| L | 1582 |
| Distinct | 62 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Bangalore | |
|---|---|
| Bhiwandi | |
| Thane | |
| Hyderabad | 100 |
| Kolkata | 92 |
| Other values (57) |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 7.627054362 |
| Min length | 4 |
Characters and Unicode
| Total characters | 12066 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 15 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | Howrah |
|---|---|
| 2nd row | Howrah |
| 3rd row | Gurgaon |
| 4th row | Gurgaon |
| 5th row | Gurgaon |
Common Values
| Value | Count | Frequency (%) |
| Bangalore | 159 | 10.1% |
| Bhiwandi | 111 | 7.0% |
| Thane | 102 | 6.4% |
| Hyderabad | 100 | 6.3% |
| Kolkata | 92 | 5.8% |
| Hosur | 90 | 5.7% |
| Coimbatore | 85 | 5.4% |
| Gurgaon | 82 | 5.2% |
| Rewari | 63 | 4.0% |
| Chennai | 61 | 3.9% |
| Other values (52) | 637 |
Length
| Value | Count | Frequency (%) |
| bangalore | 159 | 10.0% |
| bhiwandi | 111 | 7.0% |
| thane | 102 | 6.4% |
| hyderabad | 100 | 6.3% |
| kolkata | 92 | 5.8% |
| hosur | 90 | 5.7% |
| coimbatore | 85 | 5.4% |
| gurgaon | 82 | 5.2% |
| rewari | 63 | 4.0% |
| chennai | 61 | 3.8% |
| Other values (52) | 640 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2200 | |
| r | 996 | 8.3% |
| n | 864 | 7.2% |
| o | 825 | 6.8% |
| i | 733 | 6.1% |
| h | 700 | 5.8% |
| e | 630 | 5.2% |
| d | 516 | 4.3% |
| u | 454 | 3.8% |
| g | 438 | 3.6% |
| Other values (36) | 3710 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 10481 | |
| Uppercase Letter | 1582 | 13.1% |
| Space Separator | 3 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 2200 | |
| r | 996 | |
| n | 864 | 8.2% |
| o | 825 | 7.9% |
| i | 733 | 7.0% |
| h | 700 | 6.7% |
| e | 630 | 6.0% |
| d | 516 | 4.9% |
| u | 454 | 4.3% |
| g | 438 | 4.2% |
| Other values (14) | 2125 |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 300 | |
| B | 281 | |
| C | 147 | |
| T | 144 | |
| G | 118 | 7.5% |
| K | 102 | 6.4% |
| D | 70 | 4.4% |
| L | 68 | 4.3% |
| R | 67 | 4.2% |
| J | 51 | 3.2% |
| Other values (11) | 234 |
Space Separator
| Value | Count | Frequency (%) |
| 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12063 | |
| Common | 3 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 2200 | |
| r | 996 | 8.3% |
| n | 864 | 7.2% |
| o | 825 | 6.8% |
| i | 733 | 6.1% |
| h | 700 | 5.8% |
| e | 630 | 5.2% |
| d | 516 | 4.3% |
| u | 454 | 3.8% |
| g | 438 | 3.6% |
| Other values (35) | 3707 |
Common
| Value | Count | Frequency (%) |
| 3 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12066 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 2200 | |
| r | 996 | 8.3% |
| n | 864 | 7.2% |
| o | 825 | 6.8% |
| i | 733 | 6.1% |
| h | 700 | 5.8% |
| e | 630 | 5.2% |
| d | 516 | 4.3% |
| u | 454 | 3.8% |
| g | 438 | 3.6% |
| Other values (36) | 3710 |
| Distinct | 18 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Tamil Nadu | |
|---|---|
| Maharashtra | |
| Haryana | |
| West Bengal | |
| Karnataka | |
| Other values (13) |
Length
| Max length | 14 |
|---|---|
| Median length | 13 |
| Mean length | 9.415929204 |
| Min length | 5 |
Characters and Unicode
| Total characters | 14896 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | West Bengal |
|---|---|
| 2nd row | West Bengal |
| 3rd row | Haryana |
| 4th row | Haryana |
| 5th row | Haryana |
Common Values
| Value | Count | Frequency (%) |
| Tamil Nadu | 282 | |
| Maharashtra | 257 | |
| Haryana | 230 | |
| West Bengal | 219 | |
| Karnataka | 199 | |
| Telangana | 109 | 6.9% |
| Uttar Pradesh | 68 | 4.3% |
| Punjab | 56 | 3.5% |
| Bihar | 45 | 2.8% |
| Gujarat | 31 | 2.0% |
| Other values (8) | 86 | 5.4% |
Length
| Value | Count | Frequency (%) |
| tamil | 282 | |
| nadu | 282 | |
| maharashtra | 257 | |
| haryana | 230 | |
| west | 219 | |
| bengal | 219 | |
| karnataka | 199 | |
| telangana | 109 | 5.0% |
| pradesh | 103 | 4.7% |
| uttar | 68 | 3.1% |
| Other values (11) | 218 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 4061 | |
| r | 1223 | 8.2% |
| n | 956 | 6.4% |
| t | 852 | 5.7% |
| h | 723 | 4.9% |
| s | 655 | 4.4% |
| e | 653 | 4.4% |
| l | 613 | 4.1% |
| 604 | 4.1% | |
| d | 431 | 2.9% |
| Other values (24) | 4125 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 12106 | |
| Uppercase Letter | 2186 | 14.7% |
| Space Separator | 604 | 4.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 4061 | |
| r | 1223 | 10.1% |
| n | 956 | 7.9% |
| t | 852 | 7.0% |
| h | 723 | 6.0% |
| s | 655 | 5.4% |
| e | 653 | 5.4% |
| l | 613 | 5.1% |
| d | 431 | 3.6% |
| u | 369 | 3.0% |
| Other values (7) | 1570 | 13.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 391 | |
| N | 282 | |
| M | 264 | |
| B | 264 | |
| H | 230 | |
| W | 219 | |
| K | 199 | |
| P | 159 | |
| U | 68 | 3.1% |
| A | 58 | 2.7% |
| Other values (6) | 52 | 2.4% |
Space Separator
| Value | Count | Frequency (%) |
| 604 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 14292 | |
| Common | 604 | 4.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 4061 | |
| r | 1223 | 8.6% |
| n | 956 | 6.7% |
| t | 852 | 6.0% |
| h | 723 | 5.1% |
| s | 655 | 4.6% |
| e | 653 | 4.6% |
| l | 613 | 4.3% |
| d | 431 | 3.0% |
| T | 391 | 2.7% |
| Other values (23) | 3734 |
Common
| Value | Count | Frequency (%) |
| 604 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14896 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 4061 | |
| r | 1223 | 8.2% |
| n | 956 | 6.4% |
| t | 852 | 5.7% |
| h | 723 | 4.9% |
| s | 655 | 4.4% |
| e | 653 | 4.4% |
| l | 613 | 4.1% |
| 604 | 4.1% | |
| d | 431 | 2.9% |
| Other values (24) | 4125 |
| Distinct | 34 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| KA02 | |
|---|---|
| MH03 | |
| HY01 | |
| WB01 | |
| MH01 | |
| Other values (29) |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 6328 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | WB01 |
|---|---|
| 2nd row | WB01 |
| 3rd row | HY01 |
| 4th row | HY01 |
| 5th row | HY01 |
Common Values
| Value | Count | Frequency (%) |
| KA02 | 357 | |
| MH03 | 200 | |
| HY01 | 147 | |
| WB01 | 121 | 7.6% |
| MH01 | 114 | 7.2% |
| WB04 | 90 | 5.7% |
| TL02 | 73 | 4.6% |
| TN02 | 66 | 4.2% |
| HY02 | 59 | 3.7% |
| TL01 | 47 | 3.0% |
| Other values (24) | 308 |
Length
| Value | Count | Frequency (%) |
| ka02 | 357 | |
| mh03 | 200 | |
| hy01 | 147 | |
| wb01 | 121 | 7.6% |
| mh01 | 114 | 7.2% |
| wb04 | 90 | 5.7% |
| tl02 | 73 | 4.6% |
| tn02 | 66 | 4.2% |
| hy02 | 59 | 3.7% |
| tl01 | 47 | 3.0% |
| Other values (24) | 308 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1582 | |
| 2 | 629 | 9.9% |
| H | 625 | 9.9% |
| 1 | 502 | 7.9% |
| M | 375 | 5.9% |
| A | 372 | 5.9% |
| K | 363 | 5.7% |
| Y | 256 | 4.0% |
| T | 238 | 3.8% |
| 3 | 235 | 3.7% |
| Other values (16) | 1151 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3164 | |
| Uppercase Letter | 3164 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 625 | |
| M | 375 | |
| A | 372 | |
| K | 363 | |
| Y | 256 | |
| T | 238 | 7.5% |
| B | 225 | 7.1% |
| W | 218 | 6.9% |
| L | 120 | 3.8% |
| N | 111 | 3.5% |
| Other values (7) | 261 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1582 | |
| 2 | 629 | 19.9% |
| 1 | 502 | 15.9% |
| 3 | 235 | 7.4% |
| 4 | 103 | 3.3% |
| 5 | 59 | 1.9% |
| 8 | 41 | 1.3% |
| 6 | 8 | 0.3% |
| 7 | 5 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3164 | |
| Latin | 3164 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| H | 625 | |
| M | 375 | |
| A | 372 | |
| K | 363 | |
| Y | 256 | |
| T | 238 | 7.5% |
| B | 225 | 7.1% |
| W | 218 | 6.9% |
| L | 120 | 3.8% |
| N | 111 | 3.5% |
| Other values (7) | 261 |
Common
| Value | Count | Frequency (%) |
| 0 | 1582 | |
| 2 | 629 | 19.9% |
| 1 | 502 | 15.9% |
| 3 | 235 | 7.4% |
| 4 | 103 | 3.3% |
| 5 | 59 | 1.9% |
| 8 | 41 | 1.3% |
| 6 | 8 | 0.3% |
| 7 | 5 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6328 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1582 | |
| 2 | 629 | 9.9% |
| H | 625 | 9.9% |
| 1 | 502 | 7.9% |
| M | 375 | 5.9% |
| A | 372 | 5.9% |
| K | 363 | 5.7% |
| Y | 256 | 4.0% |
| T | 238 | 3.8% |
| 3 | 235 | 3.7% |
| Other values (16) | 1151 |
| Distinct | 23 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Pallet Company India Bangalore-Hobli | |
|---|---|
| Pallet Company India Kolkata | |
| Pallet Company India Bhiwandi | |
| Pallet Company India Pataudi | |
| Pallet Company India Hyderabad | |
| Other values (18) |
Length
| Max length | 41 |
|---|---|
| Median length | 37 |
| Mean length | 29.96396966 |
| Min length | 23 |
Characters and Unicode
| Total characters | 47403 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Pallet Company India Kolkata |
|---|---|
| 2nd row | Pallet Company India Kolkata |
| 3rd row | Pallet Company India Pataudi |
| 4th row | Pallet Company India Pataudi |
| 5th row | Pallet Company India Pataudi |
Common Values
| Value | Count | Frequency (%) |
| Pallet Company India Bangalore-Hobli | 357 | |
| Pallet Company India Kolkata | 211 | |
| Pallet Company India Bhiwandi | 205 | |
| Pallet Company India Pataudi | 147 | |
| Pallet Company India Hyderabad | 120 | 7.6% |
| Pallet Company India HO | 114 | 7.2% |
| Pallet Company India Chennai | 111 | 7.0% |
| Pallet Company India Ambala | 67 | 4.2% |
| Pallet Company India Lucknow | 57 | 3.6% |
| Pallet Company India Nagpur | 39 | 2.5% |
| Other values (13) | 154 |
Length
| Value | Count | Frequency (%) |
| pallet | 1582 | |
| company | 1582 | |
| india | 1582 | |
| bangalore-hobli | 357 | 5.6% |
| kolkata | 211 | 3.3% |
| bhiwandi | 205 | 3.2% |
| pataudi | 183 | 2.9% |
| hyderabad | 120 | 1.9% |
| ho | 114 | 1.8% |
| chennai | 111 | 1.7% |
| Other values (17) | 340 | 5.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 7212 | |
| 4805 | 10.1% | |
| l | 4169 | 8.8% |
| n | 4064 | 8.6% |
| i | 2751 | 5.8% |
| o | 2600 | 5.5% |
| d | 2302 | 4.9% |
| e | 2252 | 4.8% |
| t | 1991 | 4.2% |
| P | 1781 | 3.8% |
| Other values (29) | 13476 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 35311 | |
| Uppercase Letter | 6888 | 14.5% |
| Space Separator | 4805 | 10.1% |
| Dash Punctuation | 370 | 0.8% |
| Other Punctuation | 23 | < 0.1% |
| Decimal Number | 6 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 7212 | |
| l | 4169 | |
| n | 4064 | |
| i | 2751 | 7.8% |
| o | 2600 | 7.4% |
| d | 2302 | 6.5% |
| e | 2252 | 6.4% |
| t | 1991 | 5.6% |
| y | 1702 | 4.8% |
| p | 1672 | 4.7% |
| Other values (11) | 4596 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 1781 | |
| C | 1693 | |
| I | 1589 | |
| H | 591 | 8.6% |
| B | 580 | 8.4% |
| K | 240 | 3.5% |
| O | 114 | 1.7% |
| N | 85 | 1.2% |
| G | 68 | 1.0% |
| A | 67 | 1.0% |
| Other values (4) | 80 | 1.2% |
Space Separator
| Value | Count | Frequency (%) |
| 4805 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 370 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 23 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 6 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 42199 | |
| Common | 5204 | 11.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 7212 | |
| l | 4169 | 9.9% |
| n | 4064 | 9.6% |
| i | 2751 | 6.5% |
| o | 2600 | 6.2% |
| d | 2302 | 5.5% |
| e | 2252 | 5.3% |
| t | 1991 | 4.7% |
| P | 1781 | 4.2% |
| y | 1702 | 4.0% |
| Other values (25) | 11375 |
Common
| Value | Count | Frequency (%) |
| 4805 | ||
| - | 370 | 7.1% |
| . | 23 | 0.4% |
| 1 | 6 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 47403 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 7212 | |
| 4805 | 10.1% | |
| l | 4169 | 8.8% |
| n | 4064 | 8.6% |
| i | 2751 | 5.8% |
| o | 2600 | 5.5% |
| d | 2302 | 4.9% |
| e | 2252 | 4.8% |
| t | 1991 | 4.2% |
| P | 1781 | 3.8% |
| Other values (29) | 13476 |
| Distinct | 143 |
|---|---|
| Distinct (%) | 9.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10004860.78 |
| Minimum | 10000408 |
|---|---|
| Maximum | 10008338 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.5 KiB |
Quantile statistics
| Minimum | 10000408 |
|---|---|
| 5-th percentile | 10001316 |
| Q1 | 10002425 |
| median | 10006243 |
| Q3 | 10006524 |
| 95-th percentile | 10006966.9 |
| Maximum | 10008338 |
| Range | 7930 |
| Interquartile range (IQR) | 4099 |
Descriptive statistics
| Standard deviation | 2238.812447 |
|---|---|
| Coefficient of variation (CV) | 0.0002237724738 |
| Kurtosis | -1.390454343 |
| Mean | 10004860.78 |
| Median Absolute Deviation (MAD) | 480 |
| Skewness | -0.615446634 |
| Sum | 1.582768975 × 1010 |
| Variance | 5012281.171 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10002430 | 87 | 5.5% |
| 10006243 | 67 | 4.2% |
| 10006334 | 63 | 4.0% |
| 10006453 | 51 | 3.2% |
| 10002391 | 50 | 3.2% |
| 10005871 | 48 | 3.0% |
| 10001378 | 45 | 2.8% |
| 10006335 | 42 | 2.7% |
| 10002436 | 42 | 2.7% |
| 10006678 | 39 | 2.5% |
| Other values (133) | 1048 |
| Value | Count | Frequency (%) |
| 10000408 | 8 | 0.5% |
| 10000411 | 1 | 0.1% |
| 10000413 | 2 | 0.1% |
| 10000462 | 1 | 0.1% |
| 10000740 | 7 | 0.4% |
| 10001155 | 20 | |
| 10001216 | 29 | |
| 10001316 | 14 | |
| 10001317 | 4 | 0.3% |
| 10001319 | 15 |
| Value | Count | Frequency (%) |
| 10008338 | 1 | 0.1% |
| 10008314 | 5 | 0.3% |
| 10008112 | 1 | 0.1% |
| 10008009 | 1 | 0.1% |
| 10007944 | 2 | 0.1% |
| 10007809 | 19 | |
| 10007735 | 2 | 0.1% |
| 10007480 | 2 | 0.1% |
| 10007353 | 6 | 0.4% |
| 10007199 | 32 |
| Distinct | 143 |
|---|---|
| Distinct (%) | 9.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Cart Services Pvt. Ltd. - Kolkata (Bagnan) | 87 |
|---|---|
| Cart Services Pvt. Ltd. _ Coimbatore_ Selakarichal | 67 |
| Cart Services Private Limited_Rewari_Khijuri | 63 |
| Cart Services Private Limited_Bhiwandi_Saidham_G Whse_Unit 2 | 51 |
| Cart Services Pvt. Ltd. - Bangalore (Venkatapura Village, Malur ) | 50 |
| Other values (138) |
Length
| Max length | 72 |
|---|---|
| Median length | 58 |
| Mean length | 45.88874842 |
| Min length | 28 |
Characters and Unicode
| Total characters | 72596 |
|---|---|
| Distinct characters | 66 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 43 ? |
|---|---|
| Unique (%) | 2.7% |
Sample
| 1st row | Cart Services Pvt. Ltd. - Howrah (Uluberia, ESR Warehousing) |
|---|---|
| 2nd row | Cart Services Pvt. Ltd. - Howrah (Uluberia, ESR Warehousing) |
| 3rd row | Cart Services Pvt. Ltd. - Gurgoan (Embassy Industrial) |
| 4th row | Cart Services Pvt. Ltd. - Gurgoan ( Tauru) |
| 5th row | Cart Services Pvt. Ltd. - Gurgoan ( Tauru) |
Common Values
| Value | Count | Frequency (%) |
| Cart Services Pvt. Ltd. - Kolkata (Bagnan) | 87 | 5.5% |
| Cart Services Pvt. Ltd. _ Coimbatore_ Selakarichal | 67 | 4.2% |
| Cart Services Private Limited_Rewari_Khijuri | 63 | 4.0% |
| Cart Services Private Limited_Bhiwandi_Saidham_G Whse_Unit 2 | 51 | 3.2% |
| Cart Services Pvt. Ltd. - Bangalore (Venkatapura Village, Malur ) | 50 | 3.2% |
| Cart Services Pvt. Ltd. _Hosur | 48 | 3.0% |
| Cart Services Pvt. Ltd. - Ludhiana | 45 | 2.8% |
| Cart Services Private Limited_Thiruvallur_Orakkadu | 42 | 2.7% |
| Cart Services Pvt. Ltd. - Hosur (U2 BTS Large) | 42 | 2.7% |
| Cart Services Private Limited_Haringhata | 39 | 2.5% |
| Other values (133) | 1048 |
Length
| Value | Count | Frequency (%) |
| cart | 1576 | |
| services | 1576 | |
| 1224 | ||
| pvt | 1069 | 10.4% |
| ltd | 1017 | 9.9% |
| private | 513 | 5.0% |
| limited | 164 | 1.6% |
| bangalore | 150 | 1.5% |
| bhiwandi | 114 | 1.1% |
| hyderabad | 96 | 0.9% |
| Other values (201) | 2811 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8780 | 12.1% | |
| a | 6533 | 9.0% |
| r | 5483 | 7.6% |
| e | 5476 | 7.5% |
| t | 5424 | 7.5% |
| i | 4863 | 6.7% |
| v | 3298 | 4.5% |
| d | 2556 | 3.5% |
| _ | 2136 | 2.9% |
| . | 2074 | 2.9% |
| Other values (56) | 25973 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 47199 | |
| Uppercase Letter | 10533 | 14.5% |
| Space Separator | 8780 | 12.1% |
| Other Punctuation | 2170 | 3.0% |
| Connector Punctuation | 2136 | 2.9% |
| Dash Punctuation | 521 | 0.7% |
| Open Punctuation | 450 | 0.6% |
| Close Punctuation | 450 | 0.6% |
| Decimal Number | 357 | 0.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 6533 | |
| r | 5483 | |
| e | 5476 | |
| t | 5424 | |
| i | 4863 | |
| v | 3298 | 7.0% |
| d | 2556 | 5.4% |
| s | 1953 | 4.1% |
| c | 1716 | 3.6% |
| n | 1389 | 2.9% |
| Other values (15) | 8508 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1928 | |
| C | 1867 | |
| L | 1791 | |
| P | 1669 | |
| B | 621 | 5.9% |
| H | 381 | 3.6% |
| K | 255 | 2.4% |
| M | 236 | 2.2% |
| G | 210 | 2.0% |
| F | 184 | 1.7% |
| Other values (15) | 1391 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 170 | |
| 1 | 57 | 16.0% |
| 8 | 34 | 9.5% |
| 0 | 33 | 9.2% |
| 3 | 26 | 7.3% |
| 6 | 20 | 5.6% |
| 4 | 14 | 3.9% |
| 9 | 3 | 0.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 2074 | |
| , | 93 | 4.3% |
| & | 3 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 8780 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 2136 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 521 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 450 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 450 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 57732 | |
| Common | 14864 | 20.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 6533 | 11.3% |
| r | 5483 | 9.5% |
| e | 5476 | 9.5% |
| t | 5424 | 9.4% |
| i | 4863 | 8.4% |
| v | 3298 | 5.7% |
| d | 2556 | 4.4% |
| s | 1953 | 3.4% |
| S | 1928 | 3.3% |
| C | 1867 | 3.2% |
| Other values (40) | 18351 |
Common
| Value | Count | Frequency (%) |
| 8780 | ||
| _ | 2136 | 14.4% |
| . | 2074 | 14.0% |
| - | 521 | 3.5% |
| ( | 450 | 3.0% |
| ) | 450 | 3.0% |
| 2 | 170 | 1.1% |
| , | 93 | 0.6% |
| 1 | 57 | 0.4% |
| 8 | 34 | 0.2% |
| Other values (6) | 99 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 72596 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 8780 | 12.1% | |
| a | 6533 | 9.0% |
| r | 5483 | 7.6% |
| e | 5476 | 7.5% |
| t | 5424 | 7.5% |
| i | 4863 | 6.7% |
| v | 3298 | 4.5% |
| d | 2556 | 3.5% |
| _ | 2136 | 2.9% |
| . | 2074 | 2.9% |
| Other values (56) | 25973 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Allot | |
|---|---|
| Damage Swap | 15 |
| Trial | 7 |
Length
| Max length | 11 |
|---|---|
| Median length | 5 |
| Mean length | 5.056890013 |
| Min length | 5 |
Characters and Unicode
| Total characters | 8000 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Allot |
|---|---|
| 2nd row | Allot |
| 3rd row | Allot |
| 4th row | Allot |
| 5th row | Allot |
Common Values
| Value | Count | Frequency (%) |
| Allot | 1560 | |
| Damage Swap | 15 | 0.9% |
| Trial | 7 | 0.4% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| allot | 1560 | |
| damage | 15 | 0.9% |
| swap | 15 | 0.9% |
| trial | 7 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 3127 | |
| A | 1560 | |
| o | 1560 | |
| t | 1560 | |
| a | 52 | 0.7% |
| D | 15 | 0.2% |
| m | 15 | 0.2% |
| g | 15 | 0.2% |
| e | 15 | 0.2% |
| 15 | 0.2% | |
| Other values (6) | 66 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6388 | |
| Uppercase Letter | 1597 | 20.0% |
| Space Separator | 15 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 3127 | |
| o | 1560 | |
| t | 1560 | |
| a | 52 | 0.8% |
| m | 15 | 0.2% |
| g | 15 | 0.2% |
| e | 15 | 0.2% |
| w | 15 | 0.2% |
| p | 15 | 0.2% |
| r | 7 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1560 | |
| D | 15 | 0.9% |
| S | 15 | 0.9% |
| T | 7 | 0.4% |
Space Separator
| Value | Count | Frequency (%) |
| 15 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7985 | |
| Common | 15 | 0.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 3127 | |
| A | 1560 | |
| o | 1560 | |
| t | 1560 | |
| a | 52 | 0.7% |
| D | 15 | 0.2% |
| m | 15 | 0.2% |
| g | 15 | 0.2% |
| e | 15 | 0.2% |
| S | 15 | 0.2% |
| Other values (5) | 51 | 0.6% |
Common
| Value | Count | Frequency (%) |
| 15 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 3127 | |
| A | 1560 | |
| o | 1560 | |
| t | 1560 | |
| a | 52 | 0.7% |
| D | 15 | 0.2% |
| m | 15 | 0.2% |
| g | 15 | 0.2% |
| e | 15 | 0.2% |
| 15 | 0.2% | |
| Other values (6) | 66 | 0.8% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Pallet CompanyOUT |
|---|
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 17 |
| Min length | 17 |
Characters and Unicode
| Total characters | 26894 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Pallet CompanyOUT |
|---|---|
| 2nd row | Pallet CompanyOUT |
| 3rd row | Pallet CompanyOUT |
| 4th row | Pallet CompanyOUT |
| 5th row | Pallet CompanyOUT |
Common Values
| Value | Count | Frequency (%) |
| Pallet CompanyOUT | 1582 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| pallet | 1582 | |
| companyout | 1582 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 3164 | 11.8% |
| l | 3164 | 11.8% |
| P | 1582 | 5.9% |
| e | 1582 | 5.9% |
| t | 1582 | 5.9% |
| 1582 | 5.9% | |
| C | 1582 | 5.9% |
| o | 1582 | 5.9% |
| m | 1582 | 5.9% |
| p | 1582 | 5.9% |
| Other values (5) | 7910 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 17402 | |
| Uppercase Letter | 7910 | |
| Space Separator | 1582 | 5.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 3164 | |
| l | 3164 | |
| e | 1582 | |
| t | 1582 | |
| o | 1582 | |
| m | 1582 | |
| p | 1582 | |
| n | 1582 | |
| y | 1582 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 1582 | |
| C | 1582 | |
| O | 1582 | |
| U | 1582 | |
| T | 1582 |
Space Separator
| Value | Count | Frequency (%) |
| 1582 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 25312 | |
| Common | 1582 | 5.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 3164 | |
| l | 3164 | |
| P | 1582 | 6.2% |
| e | 1582 | 6.2% |
| t | 1582 | 6.2% |
| C | 1582 | 6.2% |
| o | 1582 | 6.2% |
| m | 1582 | 6.2% |
| p | 1582 | 6.2% |
| n | 1582 | 6.2% |
| Other values (4) | 6328 |
Common
| Value | Count | Frequency (%) |
| 1582 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 26894 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 3164 | 11.8% |
| l | 3164 | 11.8% |
| P | 1582 | 5.9% |
| e | 1582 | 5.9% |
| t | 1582 | 5.9% |
| 1582 | 5.9% | |
| C | 1582 | 5.9% |
| o | 1582 | 5.9% |
| m | 1582 | 5.9% |
| p | 1582 | 5.9% |
| Other values (5) | 7910 |
| Distinct | 52 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 4 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1816.297212 |
| Minimum | 0 |
|---|---|
| Maximum | 136000 |
| Zeros | 281 |
| Zeros (%) | 17.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 15 |
| 95-th percentile | 10000 |
| Maximum | 136000 |
| Range | 136000 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 7623.607054 |
|---|---|
| Coefficient of variation (CV) | 4.197334558 |
| Kurtosis | 179.0526546 |
| Mean | 1816.297212 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 11.81023856 |
| Sum | 2866117 |
| Variance | 58119384.52 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 599 | |
| 15 | 322 | |
| 0 | 281 | |
| 6 | 58 | 3.7% |
| 10 | 41 | 2.6% |
| 8500 | 36 | 2.3% |
| 5000 | 24 | 1.5% |
| 11500 | 23 | 1.5% |
| 3500 | 22 | 1.4% |
| 3000 | 16 | 1.0% |
| Other values (42) | 156 | 9.9% |
| Value | Count | Frequency (%) |
| 0 | 281 | |
| 1 | 599 | |
| 2 | 1 | 0.1% |
| 6 | 58 | 3.7% |
| 8 | 1 | 0.1% |
| 10 | 41 | 2.6% |
| 15 | 322 | |
| 20 | 1 | 0.1% |
| 1500 | 1 | 0.1% |
| 2000 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 136000 | 2 | |
| 120500 | 1 | 0.1% |
| 95000 | 1 | 0.1% |
| 62500 | 1 | 0.1% |
| 53500 | 3 | |
| 50000 | 1 | 0.1% |
| 39000 | 1 | 0.1% |
| 25000 | 1 | 0.1% |
| 21000 | 1 | 0.1% |
| 18000 | 2 |
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Pallet Company Transport borne by customer | |
|---|---|
| Customer Transport | 46 |
| Pallet Company Transport borne by Pallet Company | 16 |
| Vendor Transport | 8 |
Length
| Max length | 48 |
|---|---|
| Median length | 42 |
| Mean length | 41.23135272 |
| Min length | 16 |
Characters and Unicode
| Total characters | 65228 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Pallet Company Transport borne by customer |
|---|---|
| 2nd row | Pallet Company Transport borne by customer |
| 3rd row | Pallet Company Transport borne by customer |
| 4th row | Pallet Company Transport borne by customer |
| 5th row | Pallet Company Transport borne by customer |
Common Values
| Value | Count | Frequency (%) |
| Pallet Company Transport borne by customer | 1512 | |
| Customer Transport | 46 | 2.9% |
| Pallet Company Transport borne by Pallet Company | 16 | 1.0% |
| Vendor Transport | 8 | 0.5% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| transport | 1582 | |
| customer | 1558 | |
| pallet | 1544 | |
| company | 1544 | |
| borne | 1528 | |
| by | 1528 | |
| vendor | 8 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 7710 | ||
| r | 6258 | 9.6% |
| o | 6220 | 9.5% |
| t | 4684 | 7.2% |
| a | 4670 | 7.2% |
| n | 4662 | 7.1% |
| e | 4638 | 7.1% |
| s | 3140 | 4.8% |
| p | 3126 | 4.8% |
| m | 3102 | 4.8% |
| Other values (10) | 17018 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 52794 | |
| Space Separator | 7710 | 11.8% |
| Uppercase Letter | 4724 | 7.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 6258 | |
| o | 6220 | |
| t | 4684 | |
| a | 4670 | |
| n | 4662 | |
| e | 4638 | |
| s | 3140 | 5.9% |
| p | 3126 | 5.9% |
| m | 3102 | 5.9% |
| l | 3088 | 5.8% |
| Other values (5) | 9206 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 1590 | |
| T | 1582 | |
| P | 1544 | |
| V | 8 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 7710 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 57518 | |
| Common | 7710 | 11.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 6258 | |
| o | 6220 | |
| t | 4684 | 8.1% |
| a | 4670 | 8.1% |
| n | 4662 | 8.1% |
| e | 4638 | 8.1% |
| s | 3140 | 5.5% |
| p | 3126 | 5.4% |
| m | 3102 | 5.4% |
| l | 3088 | 5.4% |
| Other values (9) | 13930 |
Common
| Value | Count | Frequency (%) |
| 7710 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 65228 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7710 | ||
| r | 6258 | 9.6% |
| o | 6220 | 9.5% |
| t | 4684 | 7.2% |
| a | 4670 | 7.2% |
| n | 4662 | 7.1% |
| e | 4638 | 7.1% |
| s | 3140 | 4.8% |
| p | 3126 | 4.8% |
| m | 3102 | 4.8% |
| Other values (10) | 17018 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Wooden Pallet |
|---|
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Characters and Unicode
| Total characters | 20566 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Wooden Pallet |
|---|---|
| 2nd row | Wooden Pallet |
| 3rd row | Wooden Pallet |
| 4th row | Wooden Pallet |
| 5th row | Wooden Pallet |
Common Values
| Value | Count | Frequency (%) |
| Wooden Pallet | 1582 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| wooden | 1582 | |
| pallet | 1582 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 3164 | |
| e | 3164 | |
| l | 3164 | |
| W | 1582 | |
| d | 1582 | |
| n | 1582 | |
| 1582 | ||
| P | 1582 | |
| a | 1582 | |
| t | 1582 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 15820 | |
| Uppercase Letter | 3164 | 15.4% |
| Space Separator | 1582 | 7.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 3164 | |
| e | 3164 | |
| l | 3164 | |
| d | 1582 | |
| n | 1582 | |
| a | 1582 | |
| t | 1582 |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 1582 | |
| P | 1582 |
Space Separator
| Value | Count | Frequency (%) |
| 1582 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 18984 | |
| Common | 1582 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 3164 | |
| e | 3164 | |
| l | 3164 | |
| W | 1582 | |
| d | 1582 | |
| n | 1582 | |
| P | 1582 | |
| a | 1582 | |
| t | 1582 |
Common
| Value | Count | Frequency (%) |
| 1582 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20566 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 3164 | |
| e | 3164 | |
| l | 3164 | |
| W | 1582 | |
| d | 1582 | |
| n | 1582 | |
| 1582 | ||
| P | 1582 | |
| a | 1582 | |
| t | 1582 |
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| A010000023 | |
|---|---|
| A010000038 | |
| A010000003 | |
| A010000104 | 111 |
| A010000054 | 23 |
| Other values (6) | 24 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 15820 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | A010000023 |
|---|---|
| 2nd row | A010000023 |
| 3rd row | A010000054 |
| 4th row | A010000023 |
| 5th row | A010000023 |
Common Values
| Value | Count | Frequency (%) |
| A010000023 | 1182 | |
| A010000038 | 121 | 7.6% |
| A010000003 | 121 | 7.6% |
| A010000104 | 111 | 7.0% |
| A010000054 | 23 | 1.5% |
| A010000017 | 14 | 0.9% |
| A010000006 | 4 | 0.3% |
| A010000024 | 3 | 0.2% |
| A010000007 | 1 | 0.1% |
| A030000017 | 1 | 0.1% |
Length
| Value | Count | Frequency (%) |
| a010000023 | 1182 | |
| a010000038 | 121 | 7.6% |
| a010000003 | 121 | 7.6% |
| a010000104 | 111 | 7.0% |
| a010000054 | 23 | 1.5% |
| a010000017 | 14 | 0.9% |
| a010000006 | 4 | 0.3% |
| a010000024 | 3 | 0.2% |
| a010000007 | 1 | 0.1% |
| a030000017 | 1 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 9618 | |
| 1 | 1707 | 10.8% |
| A | 1582 | 10.0% |
| 3 | 1425 | 9.0% |
| 2 | 1185 | 7.5% |
| 4 | 137 | 0.9% |
| 8 | 121 | 0.8% |
| 5 | 24 | 0.2% |
| 7 | 17 | 0.1% |
| 6 | 4 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 14238 | |
| Uppercase Letter | 1582 | 10.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 9618 | |
| 1 | 1707 | 12.0% |
| 3 | 1425 | 10.0% |
| 2 | 1185 | 8.3% |
| 4 | 137 | 1.0% |
| 8 | 121 | 0.8% |
| 5 | 24 | 0.2% |
| 7 | 17 | 0.1% |
| 6 | 4 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1582 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 14238 | |
| Latin | 1582 | 10.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 9618 | |
| 1 | 1707 | 12.0% |
| 3 | 1425 | 10.0% |
| 2 | 1185 | 8.3% |
| 4 | 137 | 1.0% |
| 8 | 121 | 0.8% |
| 5 | 24 | 0.2% |
| 7 | 17 | 0.1% |
| 6 | 4 | < 0.1% |
Latin
| Value | Count | Frequency (%) |
| A | 1582 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15820 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 9618 | |
| 1 | 1707 | 10.8% |
| A | 1582 | 10.0% |
| 3 | 1425 | 9.0% |
| 2 | 1185 | 7.5% |
| 4 | 137 | 0.9% |
| 8 | 121 | 0.8% |
| 5 | 24 | 0.2% |
| 7 | 17 | 0.1% |
| 6 | 4 | < 0.1% |
| Distinct | 203 |
|---|---|
| Distinct (%) | 12.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 300.8482933 |
| Minimum | 1 |
|---|---|
| Maximum | 540 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 100 |
| Q1 | 200 |
| median | 300 |
| Q3 | 400 |
| 95-th percentile | 500 |
| Maximum | 540 |
| Range | 539 |
| Interquartile range (IQR) | 200 |
Descriptive statistics
| Standard deviation | 127.7890161 |
|---|---|
| Coefficient of variation (CV) | 0.4247623102 |
| Kurtosis | -0.8320066861 |
| Mean | 300.8482933 |
| Median Absolute Deviation (MAD) | 100 |
| Skewness | -0.007435640738 |
| Sum | 475942 |
| Variance | 16330.03263 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 300 | 341 | |
| 200 | 153 | 9.7% |
| 400 | 78 | 4.9% |
| 230 | 73 | 4.6% |
| 486 | 66 | 4.2% |
| 500 | 65 | 4.1% |
| 350 | 58 | 3.7% |
| 180 | 56 | 3.5% |
| 150 | 54 | 3.4% |
| 450 | 46 | 2.9% |
| Other values (193) | 592 |
| Value | Count | Frequency (%) |
| 1 | 5 | |
| 2 | 1 | 0.1% |
| 5 | 1 | 0.1% |
| 8 | 1 | 0.1% |
| 10 | 1 | 0.1% |
| 12 | 2 | 0.1% |
| 14 | 1 | 0.1% |
| 20 | 2 | 0.1% |
| 25 | 1 | 0.1% |
| 27 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 540 | 1 | 0.1% |
| 536 | 1 | 0.1% |
| 528 | 1 | 0.1% |
| 526 | 25 | 1.6% |
| 520 | 2 | 0.1% |
| 512 | 1 | 0.1% |
| 507 | 1 | 0.1% |
| 506 | 2 | 0.1% |
| 501 | 2 | 0.1% |
| 500 | 65 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Nos |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4746 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Nos |
|---|---|
| 2nd row | Nos |
| 3rd row | Nos |
| 4th row | Nos |
| 5th row | Nos |
Common Values
| Value | Count | Frequency (%) |
| Nos | 1582 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| nos | 1582 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 1582 | |
| o | 1582 | |
| s | 1582 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3164 | |
| Uppercase Letter | 1582 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 1582 | |
| s | 1582 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 1582 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4746 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 1582 | |
| o | 1582 | |
| s | 1582 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4746 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 1582 | |
| o | 1582 | |
| s | 1582 |
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2053.465234 |
| Minimum | 1200 |
|---|---|
| Maximum | 3375 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.5 KiB |
Quantile statistics
| Minimum | 1200 |
|---|---|
| 5-th percentile | 1500 |
| Q1 | 1950 |
| median | 1950 |
| Q3 | 1950 |
| 95-th percentile | 2890 |
| Maximum | 3375 |
| Range | 2175 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 376.8625695 |
|---|---|
| Coefficient of variation (CV) | 0.1835251765 |
| Kurtosis | 1.000093339 |
| Mean | 2053.465234 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.213583074 |
| Sum | 3248582 |
| Variance | 142025.3963 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1950 | 1182 | |
| 1500 | 125 | 7.9% |
| 2890 | 121 | 7.6% |
| 2850 | 111 | 7.0% |
| 2599 | 23 | 1.5% |
| 1250 | 14 | 0.9% |
| 2180 | 3 | 0.2% |
| 1750 | 1 | 0.1% |
| 3375 | 1 | 0.1% |
| 1200 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 1200 | 1 | 0.1% |
| 1250 | 14 | 0.9% |
| 1500 | 125 | 7.9% |
| 1750 | 1 | 0.1% |
| 1950 | 1182 | |
| 2180 | 3 | 0.2% |
| 2599 | 23 | 1.5% |
| 2850 | 111 | 7.0% |
| 2890 | 121 | 7.6% |
| 3375 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 3375 | 1 | 0.1% |
| 2890 | 121 | 7.6% |
| 2850 | 111 | 7.0% |
| 2599 | 23 | 1.5% |
| 2180 | 3 | 0.2% |
| 1950 | 1182 | |
| 1750 | 1 | 0.1% |
| 1500 | 125 | 7.9% |
| 1250 | 14 | 0.9% |
| 1200 | 1 | 0.1% |
| Distinct | 424 |
|---|---|
| Distinct (%) | 26.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| 2020/6995 | 45 |
|---|---|
| 2020/2306 | 34 |
| 2021/1802 | 33 |
| 2021/7167 | 26 |
| 2021/1433 | 26 |
| Other values (419) |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.994310999 |
| Min length | 8 |
Characters and Unicode
| Total characters | 14229 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 195 ? |
|---|---|
| Unique (%) | 12.3% |
Sample
| 1st row | 2019/493 |
|---|---|
| 2nd row | 2019/493 |
| 3rd row | 2019/1133 |
| 4th row | 2019/1309 |
| 5th row | 2019/1309 |
Common Values
| Value | Count | Frequency (%) |
| 2020/6995 | 45 | 2.8% |
| 2020/2306 | 34 | 2.1% |
| 2021/1802 | 33 | 2.1% |
| 2021/7167 | 26 | 1.6% |
| 2021/1433 | 26 | 1.6% |
| 2021/3159 | 25 | 1.6% |
| 2021/2824 | 24 | 1.5% |
| 2020/3523 | 23 | 1.5% |
| 2021/2170 | 23 | 1.5% |
| 2021/1804 | 23 | 1.5% |
| Other values (414) | 1300 |
Length
| Value | Count | Frequency (%) |
| 2020/6995 | 45 | 2.8% |
| 2020/2306 | 34 | 2.1% |
| 2021/1802 | 33 | 2.1% |
| 2021/7167 | 26 | 1.6% |
| 2021/1433 | 26 | 1.6% |
| 2021/3159 | 25 | 1.6% |
| 2021/2824 | 24 | 1.5% |
| 2020/3523 | 23 | 1.5% |
| 2021/2170 | 23 | 1.5% |
| 2021/1804 | 23 | 1.5% |
| Other values (414) | 1300 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 4287 | |
| 0 | 2772 | |
| / | 1582 | 11.1% |
| 1 | 1298 | 9.1% |
| 3 | 918 | 6.5% |
| 9 | 786 | 5.5% |
| 4 | 596 | 4.2% |
| 6 | 538 | 3.8% |
| 5 | 536 | 3.8% |
| 8 | 486 | 3.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12647 | |
| Other Punctuation | 1582 | 11.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 4287 | |
| 0 | 2772 | |
| 1 | 1298 | 10.3% |
| 3 | 918 | 7.3% |
| 9 | 786 | 6.2% |
| 4 | 596 | 4.7% |
| 6 | 538 | 4.3% |
| 5 | 536 | 4.2% |
| 8 | 486 | 3.8% |
| 7 | 430 | 3.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 1582 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 14229 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 4287 | |
| 0 | 2772 | |
| / | 1582 | 11.1% |
| 1 | 1298 | 9.1% |
| 3 | 918 | 6.5% |
| 9 | 786 | 5.5% |
| 4 | 596 | 4.2% |
| 6 | 538 | 3.8% |
| 5 | 536 | 3.8% |
| 8 | 486 | 3.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14229 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 4287 | |
| 0 | 2772 | |
| / | 1582 | 11.1% |
| 1 | 1298 | 9.1% |
| 3 | 918 | 6.5% |
| 9 | 786 | 5.5% |
| 4 | 596 | 4.2% |
| 6 | 538 | 3.8% |
| 5 | 536 | 3.8% |
| 8 | 486 | 3.4% |
SO Creation Date
Date
| Distinct | 217 |
|---|---|
| Distinct (%) | 13.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Minimum | 2019-12-05 00:00:00 |
|---|---|
| Maximum | 2022-11-17 00:00:00 |
SO Due Date
Date
| Distinct | 229 |
|---|---|
| Distinct (%) | 14.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Minimum | 2019-12-05 00:00:00 |
|---|---|
| Maximum | 2022-11-21 00:00:00 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| C | |
|---|---|
| O | 3 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1582 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | C |
| 3rd row | C |
| 4th row | C |
| 5th row | C |
Common Values
| Value | Count | Frequency (%) |
| C | 1579 | |
| O | 3 | 0.2% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| c | 1579 | |
| o | 3 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 1579 | |
| O | 3 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1582 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 1579 | |
| O | 3 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1582 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 1579 | |
| O | 3 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1582 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 1579 | |
| O | 3 | 0.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Rent | |
|---|---|
| Trial | 7 |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 4.004424779 |
| Min length | 4 |
Characters and Unicode
| Total characters | 6335 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Rent |
|---|---|
| 2nd row | Rent |
| 3rd row | Rent |
| 4th row | Rent |
| 5th row | Rent |
Common Values
| Value | Count | Frequency (%) |
| Rent | 1575 | |
| Trial | 7 | 0.4% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| rent | 1575 | |
| trial | 7 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 1575 | |
| e | 1575 | |
| n | 1575 | |
| t | 1575 | |
| T | 7 | 0.1% |
| r | 7 | 0.1% |
| i | 7 | 0.1% |
| a | 7 | 0.1% |
| l | 7 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4753 | |
| Uppercase Letter | 1582 | 25.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1575 | |
| n | 1575 | |
| t | 1575 | |
| r | 7 | 0.1% |
| i | 7 | 0.1% |
| a | 7 | 0.1% |
| l | 7 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 1575 | |
| T | 7 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6335 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 1575 | |
| e | 1575 | |
| n | 1575 | |
| t | 1575 | |
| T | 7 | 0.1% |
| r | 7 | 0.1% |
| i | 7 | 0.1% |
| a | 7 | 0.1% |
| l | 7 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6335 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 1575 | |
| e | 1575 | |
| n | 1575 | |
| t | 1575 | |
| T | 7 | 0.1% |
| r | 7 | 0.1% |
| i | 7 | 0.1% |
| a | 7 | 0.1% |
| l | 7 | 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Ecommerce | |
|---|---|
| 3PL | 7 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.973451327 |
| Min length | 3 |
Characters and Unicode
| Total characters | 14196 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Ecommerce |
|---|---|
| 2nd row | Ecommerce |
| 3rd row | Ecommerce |
| 4th row | Ecommerce |
| 5th row | Ecommerce |
Common Values
| Value | Count | Frequency (%) |
| Ecommerce | 1575 | |
| 3PL | 7 | 0.4% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| ecommerce | 1575 | |
| 3pl | 7 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 3150 | |
| m | 3150 | |
| e | 3150 | |
| E | 1575 | |
| o | 1575 | |
| r | 1575 | |
| 3 | 7 | < 0.1% |
| P | 7 | < 0.1% |
| L | 7 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 12600 | |
| Uppercase Letter | 1589 | 11.2% |
| Decimal Number | 7 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 3150 | |
| m | 3150 | |
| e | 3150 | |
| o | 1575 | |
| r | 1575 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 1575 | |
| P | 7 | 0.4% |
| L | 7 | 0.4% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 7 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 14189 | |
| Common | 7 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| c | 3150 | |
| m | 3150 | |
| e | 3150 | |
| E | 1575 | |
| o | 1575 | |
| r | 1575 | |
| P | 7 | < 0.1% |
| L | 7 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| 3 | 7 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14196 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| c | 3150 | |
| m | 3150 | |
| e | 3150 | |
| E | 1575 | |
| o | 1575 | |
| r | 1575 | |
| 3 | 7 | < 0.1% |
| P | 7 | < 0.1% |
| L | 7 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Allot |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 7910 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Allot |
|---|---|
| 2nd row | Allot |
| 3rd row | Allot |
| 4th row | Allot |
| 5th row | Allot |
Common Values
| Value | Count | Frequency (%) |
| Allot | 1582 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| allot | 1582 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 3164 | |
| A | 1582 | |
| o | 1582 | |
| t | 1582 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6328 | |
| Uppercase Letter | 1582 | 20.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 3164 | |
| o | 1582 | |
| t | 1582 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1582 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7910 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 3164 | |
| A | 1582 | |
| o | 1582 | |
| t | 1582 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7910 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 3164 | |
| A | 1582 | |
| o | 1582 | |
| t | 1582 |
| Distinct | 16 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| 32ft SXL | |
|---|---|
| 32ft MXL | |
| 40ft Open Trailer | |
| 19ft Vehicle | |
| 20ft Vehicle | |
| Other values (11) |
Length
| Max length | 22 |
|---|---|
| Median length | 8 |
| Mean length | 11.1795196 |
| Min length | 7 |
Characters and Unicode
| Total characters | 17686 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 19ft Vehicle |
|---|---|
| 2nd row | 19ft Part Load |
| 3rd row | 32ft SXL |
| 4th row | 19ft Vehicle |
| 5th row | 32ft SXL |
Common Values
| Value | Count | Frequency (%) |
| 32ft SXL | 573 | |
| 32ft MXL | 271 | |
| 40ft Open Trailer | 238 | |
| 19ft Vehicle | 194 | 12.3% |
| 20ft Vehicle | 142 | 9.0% |
| 40ft Container Trailer | 92 | 5.8% |
| 22ft Vehicle | 20 | 1.3% |
| 17ft Vehicle | 17 | 1.1% |
| 19ft Part Load | 13 | 0.8% |
| Pick Up | 5 | 0.3% |
| Other values (6) | 17 | 1.1% |
Length
| Value | Count | Frequency (%) |
| 32ft | 844 | |
| sxl | 573 | |
| vehicle | 380 | |
| 40ft | 330 | 9.4% |
| trailer | 330 | 9.4% |
| mxl | 271 | 7.7% |
| open | 238 | 6.8% |
| 19ft | 207 | 5.9% |
| 20ft | 143 | 4.1% |
| container | 92 | 2.6% |
| Other values (13) | 101 | 2.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1927 | 10.9% | |
| t | 1683 | 9.5% |
| f | 1563 | 8.8% |
| e | 1425 | 8.1% |
| 2 | 1028 | 5.8% |
| L | 858 | 4.9% |
| 3 | 846 | 4.8% |
| X | 844 | 4.8% |
| i | 807 | 4.6% |
| r | 766 | 4.3% |
| Other values (24) | 5939 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8982 | |
| Uppercase Letter | 3629 | |
| Decimal Number | 3148 | 17.8% |
| Space Separator | 1927 | 10.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 1683 | |
| f | 1563 | |
| e | 1425 | |
| i | 807 | |
| r | 766 | |
| l | 710 | |
| a | 468 | 5.2% |
| n | 422 | 4.7% |
| c | 390 | 4.3% |
| h | 380 | 4.2% |
| Other values (4) | 368 | 4.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 858 | |
| X | 844 | |
| S | 573 | |
| V | 380 | |
| T | 339 | 9.3% |
| M | 271 | 7.5% |
| O | 238 | 6.6% |
| C | 92 | 2.5% |
| P | 19 | 0.5% |
| U | 5 | 0.1% |
| Other values (2) | 10 | 0.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 1028 | |
| 3 | 846 | |
| 0 | 477 | |
| 4 | 341 | 10.8% |
| 1 | 228 | 7.2% |
| 9 | 207 | 6.6% |
| 7 | 21 | 0.7% |
Space Separator
| Value | Count | Frequency (%) |
| 1927 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12611 | |
| Common | 5075 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 1683 | |
| f | 1563 | |
| e | 1425 | |
| L | 858 | 6.8% |
| X | 844 | 6.7% |
| i | 807 | 6.4% |
| r | 766 | 6.1% |
| l | 710 | 5.6% |
| S | 573 | 4.5% |
| a | 468 | 3.7% |
| Other values (16) | 2914 |
Common
| Value | Count | Frequency (%) |
| 1927 | ||
| 2 | 1028 | |
| 3 | 846 | |
| 0 | 477 | 9.4% |
| 4 | 341 | 6.7% |
| 1 | 228 | 4.5% |
| 9 | 207 | 4.1% |
| 7 | 21 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17686 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1927 | 10.9% | |
| t | 1683 | 9.5% |
| f | 1563 | 8.8% |
| e | 1425 | 8.1% |
| 2 | 1028 | 5.8% |
| L | 858 | 4.9% |
| 3 | 846 | 4.8% |
| X | 844 | 4.8% |
| i | 807 | 4.6% |
| r | 766 | 4.3% |
| Other values (24) | 5939 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 880 | |
| True | 702 |
| Distinct | 668 |
|---|---|
| Distinct (%) | 92.6% |
| Missing | 861 |
| Missing (%) | 54.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1801.85853 |
| Minimum | 1 |
|---|---|
| Maximum | 12282 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 656 |
| Q1 | 1138 |
| median | 1444 |
| Q3 | 2102 |
| 95-th percentile | 4541 |
| Maximum | 12282 |
| Range | 12281 |
| Interquartile range (IQR) | 964 |
Descriptive statistics
| Standard deviation | 1196.054914 |
|---|---|
| Coefficient of variation (CV) | 0.6637895786 |
| Kurtosis | 16.32012094 |
| Mean | 1801.85853 |
| Median Absolute Deviation (MAD) | 409 |
| Skewness | 2.909106213 |
| Sum | 1299140 |
| Variance | 1430547.358 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1235 | 3 | 0.2% |
| 1584 | 2 | 0.1% |
| 1103 | 2 | 0.1% |
| 1225 | 2 | 0.1% |
| 1655 | 2 | 0.1% |
| 1686 | 2 | 0.1% |
| 2742 | 2 | 0.1% |
| 1168 | 2 | 0.1% |
| 1 | 2 | 0.1% |
| 1139 | 2 | 0.1% |
| Other values (658) | 700 | |
| (Missing) | 861 |
| Value | Count | Frequency (%) |
| 1 | 2 | |
| 4 | 1 | |
| 11 | 1 | |
| 32 | 1 | |
| 54 | 1 | |
| 63 | 1 | |
| 101 | 1 | |
| 142 | 1 | |
| 161 | 1 | |
| 163 | 2 |
| Value | Count | Frequency (%) |
| 12282 | 1 | |
| 12175 | 1 | |
| 5111 | 1 | |
| 5054 | 1 | |
| 5053 | 1 | |
| 5028 | 1 | |
| 5026 | 1 | |
| 5015 | 1 | |
| 5011 | 1 | |
| 4980 | 1 |
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 487 |
| Missing (%) | 30.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.66940639 |
| Minimum | 0 |
|---|---|
| Maximum | 1800 |
| Zeros | 1065 |
| Zeros (%) | 67.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1800 |
| Range | 1800 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 171.7241749 |
|---|---|
| Coefficient of variation (CV) | 6.438995019 |
| Kurtosis | 43.84584797 |
| Mean | 26.66940639 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.597955858 |
| Sum | 29203 |
| Variance | 29489.19225 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1065 | |
| 1200 | 16 | 1.0% |
| 800 | 9 | 0.6% |
| 1 | 3 | 0.2% |
| 1800 | 1 | 0.1% |
| 1000 | 1 | 0.1% |
| (Missing) | 487 |
| Value | Count | Frequency (%) |
| 0 | 1065 | |
| 1 | 3 | 0.2% |
| 800 | 9 | 0.6% |
| 1000 | 1 | 0.1% |
| 1200 | 16 | 1.0% |
| 1800 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 1800 | 1 | 0.1% |
| 1200 | 16 | 1.0% |
| 1000 | 1 | 0.1% |
| 800 | 9 | 0.6% |
| 1 | 3 | 0.2% |
| 0 | 1065 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1138 |
| Missing (%) | 71.9% |
| Memory size | 12.5 KiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1332 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 444 | 28.1% |
| (Missing) | 1138 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0.0 | 444 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 888 | |
| . | 444 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 888 | |
| Other Punctuation | 444 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 888 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 444 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1332 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 888 | |
| . | 444 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1332 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 888 | |
| . | 444 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 12.5 KiB |
| Wooden Pallet | |
|---|---|
| Wooden Pallet - SW | 1 |
Length
| Max length | 18 |
|---|---|
| Median length | 13 |
| Mean length | 13.00316056 |
| Min length | 13 |
Characters and Unicode
| Total characters | 20571 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Wooden Pallet |
|---|---|
| 2nd row | Wooden Pallet |
| 3rd row | Wooden Pallet |
| 4th row | Wooden Pallet |
| 5th row | Wooden Pallet |
Common Values
| Value | Count | Frequency (%) |
| Wooden Pallet | 1581 | |
| Wooden Pallet - SW | 1 | 0.1% |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| wooden | 1582 | |
| pallet | 1582 | |
| 1 | < 0.1% | |
| sw | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 3164 | |
| e | 3164 | |
| l | 3164 | |
| 1584 | ||
| W | 1583 | |
| d | 1582 | |
| n | 1582 | |
| P | 1582 | |
| a | 1582 | |
| t | 1582 | |
| Other values (2) | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 15820 | |
| Uppercase Letter | 3166 | 15.4% |
| Space Separator | 1584 | 7.7% |
| Dash Punctuation | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 3164 | |
| e | 3164 | |
| l | 3164 | |
| d | 1582 | |
| n | 1582 | |
| a | 1582 | |
| t | 1582 |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 1583 | |
| P | 1582 | |
| S | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1584 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 18986 | |
| Common | 1585 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 3164 | |
| e | 3164 | |
| l | 3164 | |
| W | 1583 | |
| d | 1582 | |
| n | 1582 | |
| P | 1582 | |
| a | 1582 | |
| t | 1582 | |
| S | 1 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| 1584 | ||
| - | 1 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 20571 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 3164 | |
| e | 3164 | |
| l | 3164 | |
| 1584 | ||
| W | 1583 | |
| d | 1582 | |
| n | 1582 | |
| P | 1582 | |
| a | 1582 | |
| t | 1582 | |
| Other values (2) | 2 | < 0.1% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| POSTING DATE | EFFECTIVE DATE | CREATE DATE | Customer/Vendor Code | Customer/Vendor Name | LOB | Region | BP TYPE | City | STATE | From WhsCode | From WhsName | To whsCode | TO WhsName | Model TYPE | Transfer Type | U_Frt | U_ActShipType | PRODUCT CATEGORY | ItemCode | QUANTITY | UNIT | RATE | SO ID | SO Creation Date | SO Due Date | U_DocStatus | NumAtCard | U_SOTYPE | BP CATEGORY | Document Type | Vehicle Type | Direct Dispatch | Comments | U_GRNNO | Loading/Unloading | Detention | KITITEM | U_AssetClass | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2019-12-06 | 2019-12-06 | 2019-12-06 | 10002355 | Cart Services Pvt. Ltd. _ Howrah _Uluberia ESR Warehousing | FMCG | East | RENTAL | Howrah | West Bengal | WB01 | Pallet Company India Kolkata | 10002355 | Cart Services Pvt. Ltd. - Howrah (Uluberia, ESR Warehousing) | Allot | Pallet CompanyOUT | 8500.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 200 | Nos | 1950 | 2019/493 | 2019-12-05 | 2019-12-05 | C | NaN | Rent | Ecommerce | Allot | 19ft Vehicle | N | 191900083 | NaN | 800.0 | NaN | NaN | Wooden Pallet |
| 1 | 2019-12-06 | 2019-12-06 | 2019-12-06 | 10002355 | Cart Services Pvt. Ltd. _ Howrah _Uluberia ESR Warehousing | FMCG | East | RENTAL | Howrah | West Bengal | WB01 | Pallet Company India Kolkata | 10002355 | Cart Services Pvt. Ltd. - Howrah (Uluberia, ESR Warehousing) | Allot | Pallet CompanyOUT | 8500.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 200 | Nos | 1950 | 2019/493 | 2019-12-05 | 2019-12-05 | C | NaN | Rent | Ecommerce | Allot | 19ft Part Load | N | 191900082 | NaN | 800.0 | NaN | NaN | Wooden Pallet |
| 2 | 2019-12-20 | 2019-12-20 | 2019-12-20 | 10003155 | Cart Services Pvt Ltd _ Gurgoan _Embassy Industrial | FMCG | North | RENTAL | Gurgaon | Haryana | HY01 | Pallet Company India Pataudi | 10003155 | Cart Services Pvt. Ltd. - Gurgoan (Embassy Industrial) | Allot | Pallet CompanyOUT | 4500.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000054 | 200 | Nos | 2599 | 2019/1133 | 2019-12-20 | 2019-12-27 | C | NaN | Rent | Ecommerce | Allot | 32ft SXL | N | 61900469 | NaN | 0.0 | NaN | NaN | Wooden Pallet |
| 3 | 2019-12-26 | 2019-12-26 | 2019-12-26 | 10001155 | Cart Services Pvt. Ltd. _ Gurgoan _ Tauru | FMCG | North | RENTAL | Gurgaon | Haryana | HY01 | Pallet Company India Pataudi | 10001155 | Cart Services Pvt. Ltd. - Gurgoan ( Tauru) | Allot | Pallet CompanyOUT | 3500.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 180 | Nos | 1950 | 2019/1309 | 2019-12-26 | 2020-01-02 | C | NaN | Rent | Ecommerce | Allot | 19ft Vehicle | N | 61900477 | NaN | 0.0 | NaN | NaN | Wooden Pallet |
| 4 | 2019-12-26 | 2019-12-26 | 2019-12-26 | 10001155 | Cart Services Pvt. Ltd. _ Gurgoan _ Tauru | FMCG | North | RENTAL | Gurgaon | Haryana | HY01 | Pallet Company India Pataudi | 10001155 | Cart Services Pvt. Ltd. - Gurgoan ( Tauru) | Allot | Pallet CompanyOUT | 4500.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 326 | Nos | 1950 | 2019/1309 | 2019-12-26 | 2020-01-02 | C | NaN | Rent | Ecommerce | Allot | 32ft SXL | N | 61900478 | NaN | 0.0 | NaN | NaN | Wooden Pallet |
| 5 | 2019-12-28 | 2019-12-28 | 2019-12-28 | 10001155 | Cart Services Pvt. Ltd. _ Gurgoan _ Tauru | FMCG | North | RENTAL | Gurgaon | Haryana | HY01 | Pallet Company India Pataudi | 10001155 | Cart Services Pvt. Ltd. - Gurgoan ( Tauru) | Allot | Pallet CompanyOUT | 0.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 494 | Nos | 1950 | 2019/1309 | 2019-12-26 | 2020-01-02 | C | NaN | Rent | Ecommerce | Allot | 32ft MXL | N | 61900564 | NaN | 0.0 | NaN | NaN | Wooden Pallet |
| 6 | 2020-02-07 | 2020-02-07 | 2020-02-07 | 10001497 | Cart Services Pvt. Ltd. _ Jhajjar _Flex Kulana FC | FMCG | North | RENTAL | Jhajjar | Haryana | KA02 | Pallet Company India Bangalore-Hobli | 10001497 | Cart Services Pvt. Ltd. - Jhajjar (Flex Kulana FC) | Allot | Pallet CompanyOUT | 53500.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000038 | 230 | Nos | 2890 | 2019/3204 | 2020-02-04 | 2020-02-10 | C | NaN | Rent | Ecommerce | Allot | 32ft MXL | N | 291900912 | NaN | 0.0 | NaN | NaN | Wooden Pallet |
| 7 | 2020-02-07 | 2020-02-07 | 2020-02-07 | 10001497 | Cart Services Pvt. Ltd. _ Jhajjar _Flex Kulana FC | FMCG | North | RENTAL | Jhajjar | Haryana | KA02 | Pallet Company India Bangalore-Hobli | 10001497 | Cart Services Pvt. Ltd. - Jhajjar (Flex Kulana FC) | Allot | Pallet CompanyOUT | 53500.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000038 | 230 | Nos | 2890 | 2019/3204 | 2020-02-04 | 2020-02-10 | C | NaN | Rent | Ecommerce | Allot | 32ft MXL | N | 291900914 | NaN | 0.0 | NaN | NaN | Wooden Pallet |
| 8 | 2020-02-08 | 2020-02-08 | 2020-02-08 | 10001725 | Cart Services Pvt. Ltd. _ Bhiwandi _WH B6and B8 | FMCG | West | RENTAL | Bhiwandi | Maharashtra | MH03 | Pallet Company India Bhiwandi | 10001725 | Cart Services Pvt. Ltd. - Bhiwandi (WH B6&B8) | Allot | Pallet CompanyOUT | 4000.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 300 | Nos | 1950 | 2019/3450 | 2020-02-08 | 2020-02-09 | C | NaN | Rent | Ecommerce | Allot | 32ft SXL | N | 271902158 | NaN | NaN | NaN | NaN | Wooden Pallet |
| 9 | 2020-02-17 | 2020-02-17 | 2020-02-17 | 10001497 | Cart Services Pvt. Ltd. _ Jhajjar _Flex Kulana FC | FMCG | North | RENTAL | Jhajjar | Haryana | HY01 | Pallet Company India Pataudi | 10001497 | Cart Services Pvt. Ltd. - Jhajjar (Flex Kulana FC) | Allot | Pallet CompanyOUT | 62500.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000038 | 230 | Nos | 2890 | 2019/3204 | 2020-02-04 | 2020-02-10 | C | NaN | Rent | Ecommerce | Allot | 32ft MXL | Y | 61901640 | NaN | 0.0 | NaN | NaN | Wooden Pallet |
Last rows
| POSTING DATE | EFFECTIVE DATE | CREATE DATE | Customer/Vendor Code | Customer/Vendor Name | LOB | Region | BP TYPE | City | STATE | From WhsCode | From WhsName | To whsCode | TO WhsName | Model TYPE | Transfer Type | U_Frt | U_ActShipType | PRODUCT CATEGORY | ItemCode | QUANTITY | UNIT | RATE | SO ID | SO Creation Date | SO Due Date | U_DocStatus | NumAtCard | U_SOTYPE | BP CATEGORY | Document Type | Vehicle Type | Direct Dispatch | Comments | U_GRNNO | Loading/Unloading | Detention | KITITEM | U_AssetClass | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1572 | 2022-11-14 | 2022-11-14 | 2022-11-14 | 10001216 | Cart Services Pvt. Ltd. _ Bangalore _Dasanapura | FMCG | South | RENTAL | Bangalore | Karnataka | TL02 | Pallet Company India Hyderabad | 10001216 | Cart Services Pvt. Ltd. - Bangalore (Dasanapura) | Allot | Pallet CompanyOUT | 1.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000017 | 200 | Nos | 1250 | 2022/5199 | 2022-10-29 | 2022-10-31 | C | NaN | Rent | Ecommerce | Allot | 32ft SXL | N | NaN | NaN | NaN | NaN | NaN | Wooden Pallet |
| 1573 | 2022-11-17 | 2022-11-17 | 2022-11-17 | 10006335 | Cart Services Private Limited_Thiruvallur_Orakkadu | FMCG | South | RENTAL | Tiruvallur | Tamil Nadu | TN02 | Pallet Company India Chennai | 10006335 | Cart Services Private Limited_Thiruvallur_Orakkadu | Allot | Pallet CompanyOUT | 0.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000017 | 170 | Nos | 1250 | 2022/5303 | 2022-11-02 | 2022-11-03 | C | NaN | Rent | Ecommerce | Allot | 20ft Vehicle | N | NaN | NaN | 0.0 | 0.0 | NaN | Wooden Pallet |
| 1574 | 2022-11-18 | 2022-11-18 | 2022-11-18 | 10008314 | Cart Services Private Limited_ Unnao_Hasanganj | FMCG | North | RENTAL | Unnao | Uttar Pradesh | MH01 | Pallet Company India HO | 10008314 | Cart Services Private Limited_ Unnao_Hasanganj | Allot | Pallet CompanyOUT | 15.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 450 | Nos | 1950 | 2022/5666 | 2022-11-17 | 2022-11-18 | C | NaN | Rent | 3PL | Allot | 32ft MXL | Y | NaN | 2731.0 | 0.0 | 0.0 | NaN | Wooden Pallet |
| 1575 | 2022-11-18 | 2022-11-18 | 2022-11-18 | 10001216 | Cart Services Pvt. Ltd. _ Bangalore _Dasanapura | FMCG | South | RENTAL | Bangalore | Karnataka | TN02 | Pallet Company India Chennai | 10001216 | Cart Services Pvt. Ltd. - Bangalore (Dasanapura) | Allot | Pallet CompanyOUT | 0.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000017 | 100 | Nos | 1250 | 2022/5199 | 2022-10-29 | 2022-10-31 | C | NaN | Rent | Ecommerce | Allot | 17ft Vehicle | N | NaN | NaN | 0.0 | 0.0 | NaN | Wooden Pallet |
| 1576 | 2022-11-19 | 2022-11-19 | 2022-11-19 | 10006335 | Cart Services Private Limited_Thiruvallur_Orakkadu | FMCG | South | RENTAL | Tiruvallur | Tamil Nadu | TN02 | Pallet Company India Chennai | 10006335 | Cart Services Private Limited_Thiruvallur_Orakkadu | Allot | Pallet CompanyOUT | 0.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000017 | 180 | Nos | 1250 | 2022/5303 | 2022-11-02 | 2022-11-03 | C | NaN | Rent | Ecommerce | Allot | 20ft Vehicle | N | NaN | NaN | 0.0 | 0.0 | NaN | Wooden Pallet |
| 1577 | 2022-11-19 | 2022-11-19 | 2022-11-19 | 10008314 | Cart Services Private Limited_ Unnao_Hasanganj | FMCG | North | RENTAL | Unnao | Uttar Pradesh | MH01 | Pallet Company India HO | 10008314 | Cart Services Private Limited_ Unnao_Hasanganj | Allot | Pallet CompanyOUT | 15.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 500 | Nos | 1950 | 2022/5666 | 2022-11-17 | 2022-11-18 | C | NaN | Rent | 3PL | Allot | 32ft MXL | Y | NaN | 2742.0 | 0.0 | 0.0 | NaN | Wooden Pallet |
| 1578 | 2022-11-21 | 2022-11-21 | 2022-11-21 | 10008314 | Cart Services Private Limited_ Unnao_Hasanganj | FMCG | North | RENTAL | Unnao | Uttar Pradesh | MH01 | Pallet Company India HO | 10008314 | Cart Services Private Limited_ Unnao_Hasanganj | Allot | Pallet CompanyOUT | 15.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 490 | Nos | 1950 | 2022/5666 | 2022-11-17 | 2022-11-18 | O | NaN | Rent | 3PL | Allot | 32ft MXL | Y | NaN | 2758.0 | NaN | NaN | NaN | Wooden Pallet |
| 1579 | 2022-11-22 | 2022-11-22 | 2022-11-22 | 10006814 | Cart Services Pvt. Ltd. _ Bhiwandi_CF | FMCG | West | RENTAL | Thane | Maharashtra | MH07 | Pallet Company India Bhiwandi | 10006814 | Cart Services Pvt. Ltd. _ Bhiwandi_CF | Allot | Pallet CompanyOUT | 6.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000017 | 200 | Nos | 1250 | 2022/5595 | 2022-11-14 | 2022-11-17 | C | NaN | Rent | Ecommerce | Allot | 20ft Vehicle | N | NaN | NaN | NaN | NaN | NaN | Wooden Pallet |
| 1580 | 2022-11-26 | 2022-11-26 | 2022-11-26 | 10006524 | Cart Services Pvt. Ltd. _ Hyderabad _Pudur | FMCG | South | RENTAL | Hyderabad | Telangana | MH07 | Pallet Company India Bhiwandi | 10006524 | Cart Services Pvt. Ltd. _ Hyderabad _Pudur | Allot | Pallet CompanyOUT | 1.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000017 | 200 | Nos | 1250 | 2022/5650 | 2022-11-17 | 2022-11-21 | O | NaN | Rent | Ecommerce | Allot | 32ft SXL | N | NaN | NaN | NaN | NaN | NaN | Wooden Pallet |
| 1581 | 2022-11-26 | 2022-11-26 | 2022-11-26 | 10008338 | Cart Services Private Limited_Hyderabad_Medchal_Pudur | FMCG | South | RENTAL | Hyderabad | Telangana | MH07 | Pallet Company India Bhiwandi | 10008338 | Cart Services Private Limited_Hyderabad_Medchal_Pudur | Allot | Pallet CompanyOUT | 1.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000017 | 200 | Nos | 1250 | 2022/5612 | 2022-11-15 | 2022-11-17 | O | NaN | Rent | Ecommerce | Allot | 32ft SXL | N | NaN | NaN | NaN | NaN | NaN | Wooden Pallet |
Most frequently occurring
| POSTING DATE | EFFECTIVE DATE | CREATE DATE | Customer/Vendor Code | Customer/Vendor Name | LOB | Region | BP TYPE | City | STATE | From WhsCode | From WhsName | To whsCode | TO WhsName | Model TYPE | Transfer Type | U_Frt | U_ActShipType | PRODUCT CATEGORY | ItemCode | QUANTITY | UNIT | RATE | SO ID | SO Creation Date | SO Due Date | U_DocStatus | U_SOTYPE | BP CATEGORY | Document Type | Vehicle Type | Direct Dispatch | U_GRNNO | Loading/Unloading | Detention | U_AssetClass | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 72 | 2021-12-29 | 2021-12-29 | 2021-12-29 | 10007199 | Cart Services Private Limited_Dharwad FC | FMCG | South | RENTAL | Dharwad | Karnataka | KA02 | Pallet Company India Bangalore-Hobli | 10007199 | Cart Services Private Limited_Dharwad FC | Allot | Pallet CompanyOUT | 1.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 300 | Nos | 1950 | 2021/7167 | 2021-12-23 | 2021-12-24 | C | Rent | Ecommerce | Allot | 32ft SXL | N | NaN | NaN | NaN | Wooden Pallet | 6 |
| 19 | 2020-09-05 | 2020-09-05 | 2020-09-05 | 10003155 | Cart Services Pvt Ltd _ Gurgoan _Embassy Industrial | FMCG | North | RENTAL | Gurgaon | Haryana | MH03 | Pallet Company India Bhiwandi | 10003155 | Cart Services Pvt. Ltd. - Gurgoan (Embassy Industrial) | Allot | Pallet CompanyOUT | 6.0 | Customer Transport | Wooden Pallet | A010000038 | 107 | Nos | 2890 | 2020/3368 | 2020-09-05 | 2020-09-07 | C | Rent | Ecommerce | Allot | 32ft SXL | N | NaN | NaN | NaN | Wooden Pallet | 5 |
| 40 | 2021-01-04 | 2021-01-04 | 2021-01-04 | 10006243 | Cart Services Pvt. Ltd. _ Coimbatore_ Selakarichal | FMCG | South | RENTAL | Coimbatore | Tamil Nadu | KA02 | Pallet Company India Bangalore-Hobli | 10006243 | Cart Services Pvt. Ltd. _ Coimbatore_ Selakarichal | Allot | Pallet CompanyOUT | 15.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 350 | Nos | 1950 | 2020/6995 | 2020-12-08 | 2021-01-02 | C | Rent | Ecommerce | Allot | 32ft MXL | N | NaN | 0.0 | NaN | Wooden Pallet | 5 |
| 69 | 2021-12-25 | 2021-12-25 | 2021-12-25 | 10007199 | Cart Services Private Limited_Dharwad FC | FMCG | South | RENTAL | Dharwad | Karnataka | KA02 | Pallet Company India Bangalore-Hobli | 10007199 | Cart Services Private Limited_Dharwad FC | Allot | Pallet CompanyOUT | 1.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 322 | Nos | 1950 | 2021/7167 | 2021-12-23 | 2021-12-24 | C | Rent | Ecommerce | Allot | 32ft SXL | N | NaN | NaN | NaN | Wooden Pallet | 5 |
| 17 | 2020-09-05 | 2020-09-05 | 2020-09-05 | 10001497 | Cart Services Pvt. Ltd. _ Jhajjar _Flex Kulana FC | FMCG | North | RENTAL | Jhajjar | Haryana | MH03 | Pallet Company India Bhiwandi | 10001497 | Cart Services Pvt. Ltd. - Jhajjar (Flex Kulana FC) | Allot | Pallet CompanyOUT | 6.0 | Customer Transport | Wooden Pallet | A010000038 | 105 | Nos | 2890 | 2020/3334 | 2020-09-04 | 2020-09-05 | C | Rent | Ecommerce | Allot | 32ft SXL | N | NaN | NaN | NaN | Wooden Pallet | 4 |
| 70 | 2021-12-27 | 2021-12-27 | 2021-12-27 | 10007199 | Cart Services Private Limited_Dharwad FC | FMCG | South | RENTAL | Dharwad | Karnataka | KA02 | Pallet Company India Bangalore-Hobli | 10007199 | Cart Services Private Limited_Dharwad FC | Allot | Pallet CompanyOUT | 1.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 322 | Nos | 1950 | 2021/7167 | 2021-12-23 | 2021-12-24 | C | Rent | Ecommerce | Allot | 32ft SXL | N | NaN | NaN | NaN | Wooden Pallet | 4 |
| 71 | 2021-12-28 | 2021-12-28 | 2021-12-28 | 10007199 | Cart Services Private Limited_Dharwad FC | FMCG | South | RENTAL | Dharwad | Karnataka | KA02 | Pallet Company India Bangalore-Hobli | 10007199 | Cart Services Private Limited_Dharwad FC | Allot | Pallet CompanyOUT | 1.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 300 | Nos | 1950 | 2021/7167 | 2021-12-23 | 2021-12-24 | C | Rent | Ecommerce | Allot | 32ft SXL | N | NaN | NaN | NaN | Wooden Pallet | 4 |
| 73 | 2021-12-30 | 2021-12-30 | 2021-12-30 | 10007199 | Cart Services Private Limited_Dharwad FC | FMCG | South | RENTAL | Dharwad | Karnataka | KA02 | Pallet Company India Bangalore-Hobli | 10007199 | Cart Services Private Limited_Dharwad FC | Allot | Pallet CompanyOUT | 1.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000023 | 300 | Nos | 1950 | 2021/7167 | 2021-12-23 | 2021-12-24 | C | Rent | Ecommerce | Allot | 32ft SXL | N | NaN | NaN | NaN | Wooden Pallet | 4 |
| 1 | 2020-07-30 | 2020-07-30 | 2020-07-30 | 10002391 | Cart Services Pvt. Ltd. _ Bangalore _Venkatapura Village Malur | FMCG | South | RENTAL | Bangalore | Karnataka | KA02 | Pallet Company India Bangalore-Hobli | 10002391 | Cart Services Pvt. Ltd. - Bangalore (Venkatapura Village, Malur ) | Allot | Pallet CompanyOUT | 12000.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000003 | 300 | Nos | 1500 | 2020/1987 | 2020-07-30 | 2020-07-31 | C | Rent | Ecommerce | Allot | 32ft SXL | N | NaN | 0.0 | NaN | Wooden Pallet | 3 |
| 10 | 2020-08-10 | 2020-08-10 | 2020-08-10 | 10005874 | Cart Services Private Limited _ Bhiwandi_ Saidham, G Warehouse | FMCG | West | RENTAL | Thane | Maharashtra | MH03 | Pallet Company India Bhiwandi | 10005874 | Cart Services Private Limited _ Bhiwandi_ Saidham, G Warehouse | Allot | Pallet CompanyOUT | 5000.0 | Pallet Company Transport borne by customer | Wooden Pallet | A010000003 | 300 | Nos | 1500 | 2020/2294 | 2020-08-07 | 2020-08-21 | C | Rent | Ecommerce | Allot | 32ft SXL | N | NaN | NaN | NaN | Wooden Pallet | 3 |